Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_PROXY_ARCHIVELOG_DETAILS

`RC_PROXY_ARCHIVELOG_DETAILS` provides detailed information about proxy copy backups of archived redo log for each database registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`SESSION_KEY` | `NUMBER` | Session identifier. Use in joins with RC_RMAN_OUTPUT.
`SESSION_RECID` | `NUMBER` | Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`SESSION_STAMP` | `NUMBER` | Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`COPY_KEY` | `NUMBER` | Unique identifier for this proxy copy.
`THREAD#` | `NUMBER` | Redo thread number for the archived redo log file that was backed up.
`SEQUENCE#` | `NUMBER` | Log sequence number for the archived redo log file that was backed up.
`RESETLOGS_CHANGE#` | `NUMBER` | Checkpoint SCN of OPEN RESETLOGS for incarnation of the database of the archived redo log file that was backed up.
`RESETLOGS_TIME` | `DATE` | Time corresponding to `RESETLOGS_CHANGE#`.
`HANDLE` | `VARCHAR2(1024)` | A filename for the proxy copy.
`MEDIA` | `VARCHAR2(80)` | A comment that contains further information about the media manager that created this backup.
`MEDIA_POOL` | `NUMBER` | The number of the media pool in which the backup is stored.
`TAG` | `VARCHAR2(32)` | Tag specified for this backup.
`FIRST_CHANGE#` | `NUMBER` | First change SCN included in the archived redo log file.
`NEXT_CHANGE#` | `NUMBER` | Next change SCN after this archived redo log file.
`FIRST_TIME` | `DATE` | Time corresponding to FIRST_CHANGE#.
`NEXT_TIME` | `DATE` | Time corresponding to NEXT_CHANGE#.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output pieces generated by this job.
`COMPLETION_TIME` | `DATE` | The time at which the job was completed.
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.